package jddk;

import com.alibaba.druid.sql.PagerUtils;
import com.alibaba.druid.util.JdbcUtils;

/**
 * 
 * @author GuoJian
 *
 */
public class JdbcTest {

	public static void main(String[] args) {

		String aa = PagerUtils.count("select * from aa order by name", JdbcUtils.ORACLE);

		System.out.println(aa);

		System.out.println("=======================================");

		String bb = PagerUtils.limit("select * from aa order by name", JdbcUtils.ORACLE, 1, 10);

		System.out.println(bb);

		System.out.println("========================================");

		String sql = " select id from user where name='guojian' ";

		String ss = PagerUtils.limit(sql, JdbcUtils.SQL_SERVER, 1, 10);

		System.out.println(ss);

	}

}
